package com.desksoft.ecommerce.entity.logistics.dto;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class PersonExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public PersonExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andPersidIsNull() {
            addCriterion("PersID is null");
            return (Criteria) this;
        }

        public Criteria andPersidIsNotNull() {
            addCriterion("PersID is not null");
            return (Criteria) this;
        }

        public Criteria andPersidEqualTo(String value) {
            addCriterion("PersID =", value, "persid");
            return (Criteria) this;
        }

        public Criteria andPersidNotEqualTo(String value) {
            addCriterion("PersID <>", value, "persid");
            return (Criteria) this;
        }

        public Criteria andPersidGreaterThan(String value) {
            addCriterion("PersID >", value, "persid");
            return (Criteria) this;
        }

        public Criteria andPersidGreaterThanOrEqualTo(String value) {
            addCriterion("PersID >=", value, "persid");
            return (Criteria) this;
        }

        public Criteria andPersidLessThan(String value) {
            addCriterion("PersID <", value, "persid");
            return (Criteria) this;
        }

        public Criteria andPersidLessThanOrEqualTo(String value) {
            addCriterion("PersID <=", value, "persid");
            return (Criteria) this;
        }

        public Criteria andPersidLike(String value) {
            addCriterion("PersID like", value, "persid");
            return (Criteria) this;
        }

        public Criteria andPersidNotLike(String value) {
            addCriterion("PersID not like", value, "persid");
            return (Criteria) this;
        }

        public Criteria andPersidIn(List<String> values) {
            addCriterion("PersID in", values, "persid");
            return (Criteria) this;
        }

        public Criteria andPersidNotIn(List<String> values) {
            addCriterion("PersID not in", values, "persid");
            return (Criteria) this;
        }

        public Criteria andPersidBetween(String value1, String value2) {
            addCriterion("PersID between", value1, value2, "persid");
            return (Criteria) this;
        }

        public Criteria andPersidNotBetween(String value1, String value2) {
            addCriterion("PersID not between", value1, value2, "persid");
            return (Criteria) this;
        }

        public Criteria andUseridIsNull() {
            addCriterion("UserID is null");
            return (Criteria) this;
        }

        public Criteria andUseridIsNotNull() {
            addCriterion("UserID is not null");
            return (Criteria) this;
        }

        public Criteria andUseridEqualTo(String value) {
            addCriterion("UserID =", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotEqualTo(String value) {
            addCriterion("UserID <>", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThan(String value) {
            addCriterion("UserID >", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThanOrEqualTo(String value) {
            addCriterion("UserID >=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThan(String value) {
            addCriterion("UserID <", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThanOrEqualTo(String value) {
            addCriterion("UserID <=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLike(String value) {
            addCriterion("UserID like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotLike(String value) {
            addCriterion("UserID not like", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridIn(List<String> values) {
            addCriterion("UserID in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotIn(List<String> values) {
            addCriterion("UserID not in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridBetween(String value1, String value2) {
            addCriterion("UserID between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotBetween(String value1, String value2) {
            addCriterion("UserID not between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andPersnameIsNull() {
            addCriterion("PersName is null");
            return (Criteria) this;
        }

        public Criteria andPersnameIsNotNull() {
            addCriterion("PersName is not null");
            return (Criteria) this;
        }

        public Criteria andPersnameEqualTo(String value) {
            addCriterion("PersName =", value, "persname");
            return (Criteria) this;
        }

        public Criteria andPersnameNotEqualTo(String value) {
            addCriterion("PersName <>", value, "persname");
            return (Criteria) this;
        }

        public Criteria andPersnameGreaterThan(String value) {
            addCriterion("PersName >", value, "persname");
            return (Criteria) this;
        }

        public Criteria andPersnameGreaterThanOrEqualTo(String value) {
            addCriterion("PersName >=", value, "persname");
            return (Criteria) this;
        }

        public Criteria andPersnameLessThan(String value) {
            addCriterion("PersName <", value, "persname");
            return (Criteria) this;
        }

        public Criteria andPersnameLessThanOrEqualTo(String value) {
            addCriterion("PersName <=", value, "persname");
            return (Criteria) this;
        }

        public Criteria andPersnameLike(String value) {
            addCriterion("PersName like", value, "persname");
            return (Criteria) this;
        }

        public Criteria andPersnameNotLike(String value) {
            addCriterion("PersName not like", value, "persname");
            return (Criteria) this;
        }

        public Criteria andPersnameIn(List<String> values) {
            addCriterion("PersName in", values, "persname");
            return (Criteria) this;
        }

        public Criteria andPersnameNotIn(List<String> values) {
            addCriterion("PersName not in", values, "persname");
            return (Criteria) this;
        }

        public Criteria andPersnameBetween(String value1, String value2) {
            addCriterion("PersName between", value1, value2, "persname");
            return (Criteria) this;
        }

        public Criteria andPersnameNotBetween(String value1, String value2) {
            addCriterion("PersName not between", value1, value2, "persname");
            return (Criteria) this;
        }

        public Criteria andPwdIsNull() {
            addCriterion("PWD is null");
            return (Criteria) this;
        }

        public Criteria andPwdIsNotNull() {
            addCriterion("PWD is not null");
            return (Criteria) this;
        }

        public Criteria andPwdEqualTo(String value) {
            addCriterion("PWD =", value, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdNotEqualTo(String value) {
            addCriterion("PWD <>", value, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdGreaterThan(String value) {
            addCriterion("PWD >", value, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdGreaterThanOrEqualTo(String value) {
            addCriterion("PWD >=", value, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdLessThan(String value) {
            addCriterion("PWD <", value, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdLessThanOrEqualTo(String value) {
            addCriterion("PWD <=", value, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdLike(String value) {
            addCriterion("PWD like", value, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdNotLike(String value) {
            addCriterion("PWD not like", value, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdIn(List<String> values) {
            addCriterion("PWD in", values, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdNotIn(List<String> values) {
            addCriterion("PWD not in", values, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdBetween(String value1, String value2) {
            addCriterion("PWD between", value1, value2, "pwd");
            return (Criteria) this;
        }

        public Criteria andPwdNotBetween(String value1, String value2) {
            addCriterion("PWD not between", value1, value2, "pwd");
            return (Criteria) this;
        }

        public Criteria andPersnoIsNull() {
            addCriterion("PersNo is null");
            return (Criteria) this;
        }

        public Criteria andPersnoIsNotNull() {
            addCriterion("PersNo is not null");
            return (Criteria) this;
        }

        public Criteria andPersnoEqualTo(String value) {
            addCriterion("PersNo =", value, "persno");
            return (Criteria) this;
        }

        public Criteria andPersnoNotEqualTo(String value) {
            addCriterion("PersNo <>", value, "persno");
            return (Criteria) this;
        }

        public Criteria andPersnoGreaterThan(String value) {
            addCriterion("PersNo >", value, "persno");
            return (Criteria) this;
        }

        public Criteria andPersnoGreaterThanOrEqualTo(String value) {
            addCriterion("PersNo >=", value, "persno");
            return (Criteria) this;
        }

        public Criteria andPersnoLessThan(String value) {
            addCriterion("PersNo <", value, "persno");
            return (Criteria) this;
        }

        public Criteria andPersnoLessThanOrEqualTo(String value) {
            addCriterion("PersNo <=", value, "persno");
            return (Criteria) this;
        }

        public Criteria andPersnoLike(String value) {
            addCriterion("PersNo like", value, "persno");
            return (Criteria) this;
        }

        public Criteria andPersnoNotLike(String value) {
            addCriterion("PersNo not like", value, "persno");
            return (Criteria) this;
        }

        public Criteria andPersnoIn(List<String> values) {
            addCriterion("PersNo in", values, "persno");
            return (Criteria) this;
        }

        public Criteria andPersnoNotIn(List<String> values) {
            addCriterion("PersNo not in", values, "persno");
            return (Criteria) this;
        }

        public Criteria andPersnoBetween(String value1, String value2) {
            addCriterion("PersNo between", value1, value2, "persno");
            return (Criteria) this;
        }

        public Criteria andPersnoNotBetween(String value1, String value2) {
            addCriterion("PersNo not between", value1, value2, "persno");
            return (Criteria) this;
        }

        public Criteria andSexIsNull() {
            addCriterion("Sex is null");
            return (Criteria) this;
        }

        public Criteria andSexIsNotNull() {
            addCriterion("Sex is not null");
            return (Criteria) this;
        }

        public Criteria andSexEqualTo(String value) {
            addCriterion("Sex =", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotEqualTo(String value) {
            addCriterion("Sex <>", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThan(String value) {
            addCriterion("Sex >", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThanOrEqualTo(String value) {
            addCriterion("Sex >=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThan(String value) {
            addCriterion("Sex <", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThanOrEqualTo(String value) {
            addCriterion("Sex <=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLike(String value) {
            addCriterion("Sex like", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotLike(String value) {
            addCriterion("Sex not like", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexIn(List<String> values) {
            addCriterion("Sex in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotIn(List<String> values) {
            addCriterion("Sex not in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexBetween(String value1, String value2) {
            addCriterion("Sex between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotBetween(String value1, String value2) {
            addCriterion("Sex not between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andNationIsNull() {
            addCriterion("Nation is null");
            return (Criteria) this;
        }

        public Criteria andNationIsNotNull() {
            addCriterion("Nation is not null");
            return (Criteria) this;
        }

        public Criteria andNationEqualTo(String value) {
            addCriterion("Nation =", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationNotEqualTo(String value) {
            addCriterion("Nation <>", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationGreaterThan(String value) {
            addCriterion("Nation >", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationGreaterThanOrEqualTo(String value) {
            addCriterion("Nation >=", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationLessThan(String value) {
            addCriterion("Nation <", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationLessThanOrEqualTo(String value) {
            addCriterion("Nation <=", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationLike(String value) {
            addCriterion("Nation like", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationNotLike(String value) {
            addCriterion("Nation not like", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationIn(List<String> values) {
            addCriterion("Nation in", values, "nation");
            return (Criteria) this;
        }

        public Criteria andNationNotIn(List<String> values) {
            addCriterion("Nation not in", values, "nation");
            return (Criteria) this;
        }

        public Criteria andNationBetween(String value1, String value2) {
            addCriterion("Nation between", value1, value2, "nation");
            return (Criteria) this;
        }

        public Criteria andNationNotBetween(String value1, String value2) {
            addCriterion("Nation not between", value1, value2, "nation");
            return (Criteria) this;
        }

        public Criteria andNativedIsNull() {
            addCriterion("Native is null");
            return (Criteria) this;
        }

        public Criteria andNativedIsNotNull() {
            addCriterion("Native is not null");
            return (Criteria) this;
        }

        public Criteria andNativedEqualTo(String value) {
            addCriterion("Native =", value, "natived");
            return (Criteria) this;
        }

        public Criteria andNativedNotEqualTo(String value) {
            addCriterion("Native <>", value, "natived");
            return (Criteria) this;
        }

        public Criteria andNativedGreaterThan(String value) {
            addCriterion("Native >", value, "natived");
            return (Criteria) this;
        }

        public Criteria andNativedGreaterThanOrEqualTo(String value) {
            addCriterion("Native >=", value, "natived");
            return (Criteria) this;
        }

        public Criteria andNativedLessThan(String value) {
            addCriterion("Native <", value, "natived");
            return (Criteria) this;
        }

        public Criteria andNativedLessThanOrEqualTo(String value) {
            addCriterion("Native <=", value, "natived");
            return (Criteria) this;
        }

        public Criteria andNativedLike(String value) {
            addCriterion("Native like", value, "natived");
            return (Criteria) this;
        }

        public Criteria andNativedNotLike(String value) {
            addCriterion("Native not like", value, "natived");
            return (Criteria) this;
        }

        public Criteria andNativedIn(List<String> values) {
            addCriterion("Native in", values, "natived");
            return (Criteria) this;
        }

        public Criteria andNativedNotIn(List<String> values) {
            addCriterion("Native not in", values, "natived");
            return (Criteria) this;
        }

        public Criteria andNativedBetween(String value1, String value2) {
            addCriterion("Native between", value1, value2, "natived");
            return (Criteria) this;
        }

        public Criteria andNativedNotBetween(String value1, String value2) {
            addCriterion("Native not between", value1, value2, "natived");
            return (Criteria) this;
        }

        public Criteria andBirthdayIsNull() {
            addCriterion("Birthday is null");
            return (Criteria) this;
        }

        public Criteria andBirthdayIsNotNull() {
            addCriterion("Birthday is not null");
            return (Criteria) this;
        }

        public Criteria andBirthdayEqualTo(Date value) {
            addCriterion("Birthday =", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayNotEqualTo(Date value) {
            addCriterion("Birthday <>", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayGreaterThan(Date value) {
            addCriterion("Birthday >", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayGreaterThanOrEqualTo(Date value) {
            addCriterion("Birthday >=", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayLessThan(Date value) {
            addCriterion("Birthday <", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayLessThanOrEqualTo(Date value) {
            addCriterion("Birthday <=", value, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayIn(List<Date> values) {
            addCriterion("Birthday in", values, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayNotIn(List<Date> values) {
            addCriterion("Birthday not in", values, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayBetween(Date value1, Date value2) {
            addCriterion("Birthday between", value1, value2, "birthday");
            return (Criteria) this;
        }

        public Criteria andBirthdayNotBetween(Date value1, Date value2) {
            addCriterion("Birthday not between", value1, value2, "birthday");
            return (Criteria) this;
        }

        public Criteria andEducationIsNull() {
            addCriterion("Education is null");
            return (Criteria) this;
        }

        public Criteria andEducationIsNotNull() {
            addCriterion("Education is not null");
            return (Criteria) this;
        }

        public Criteria andEducationEqualTo(String value) {
            addCriterion("Education =", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationNotEqualTo(String value) {
            addCriterion("Education <>", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationGreaterThan(String value) {
            addCriterion("Education >", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationGreaterThanOrEqualTo(String value) {
            addCriterion("Education >=", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationLessThan(String value) {
            addCriterion("Education <", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationLessThanOrEqualTo(String value) {
            addCriterion("Education <=", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationLike(String value) {
            addCriterion("Education like", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationNotLike(String value) {
            addCriterion("Education not like", value, "education");
            return (Criteria) this;
        }

        public Criteria andEducationIn(List<String> values) {
            addCriterion("Education in", values, "education");
            return (Criteria) this;
        }

        public Criteria andEducationNotIn(List<String> values) {
            addCriterion("Education not in", values, "education");
            return (Criteria) this;
        }

        public Criteria andEducationBetween(String value1, String value2) {
            addCriterion("Education between", value1, value2, "education");
            return (Criteria) this;
        }

        public Criteria andEducationNotBetween(String value1, String value2) {
            addCriterion("Education not between", value1, value2, "education");
            return (Criteria) this;
        }

        public Criteria andPoliticsIsNull() {
            addCriterion("Politics is null");
            return (Criteria) this;
        }

        public Criteria andPoliticsIsNotNull() {
            addCriterion("Politics is not null");
            return (Criteria) this;
        }

        public Criteria andPoliticsEqualTo(String value) {
            addCriterion("Politics =", value, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsNotEqualTo(String value) {
            addCriterion("Politics <>", value, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsGreaterThan(String value) {
            addCriterion("Politics >", value, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsGreaterThanOrEqualTo(String value) {
            addCriterion("Politics >=", value, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsLessThan(String value) {
            addCriterion("Politics <", value, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsLessThanOrEqualTo(String value) {
            addCriterion("Politics <=", value, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsLike(String value) {
            addCriterion("Politics like", value, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsNotLike(String value) {
            addCriterion("Politics not like", value, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsIn(List<String> values) {
            addCriterion("Politics in", values, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsNotIn(List<String> values) {
            addCriterion("Politics not in", values, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsBetween(String value1, String value2) {
            addCriterion("Politics between", value1, value2, "politics");
            return (Criteria) this;
        }

        public Criteria andPoliticsNotBetween(String value1, String value2) {
            addCriterion("Politics not between", value1, value2, "politics");
            return (Criteria) this;
        }

        public Criteria andJointimeIsNull() {
            addCriterion("JoinTime is null");
            return (Criteria) this;
        }

        public Criteria andJointimeIsNotNull() {
            addCriterion("JoinTime is not null");
            return (Criteria) this;
        }

        public Criteria andJointimeEqualTo(Date value) {
            addCriterion("JoinTime =", value, "jointime");
            return (Criteria) this;
        }

        public Criteria andJointimeNotEqualTo(Date value) {
            addCriterion("JoinTime <>", value, "jointime");
            return (Criteria) this;
        }

        public Criteria andJointimeGreaterThan(Date value) {
            addCriterion("JoinTime >", value, "jointime");
            return (Criteria) this;
        }

        public Criteria andJointimeGreaterThanOrEqualTo(Date value) {
            addCriterion("JoinTime >=", value, "jointime");
            return (Criteria) this;
        }

        public Criteria andJointimeLessThan(Date value) {
            addCriterion("JoinTime <", value, "jointime");
            return (Criteria) this;
        }

        public Criteria andJointimeLessThanOrEqualTo(Date value) {
            addCriterion("JoinTime <=", value, "jointime");
            return (Criteria) this;
        }

        public Criteria andJointimeIn(List<Date> values) {
            addCriterion("JoinTime in", values, "jointime");
            return (Criteria) this;
        }

        public Criteria andJointimeNotIn(List<Date> values) {
            addCriterion("JoinTime not in", values, "jointime");
            return (Criteria) this;
        }

        public Criteria andJointimeBetween(Date value1, Date value2) {
            addCriterion("JoinTime between", value1, value2, "jointime");
            return (Criteria) this;
        }

        public Criteria andJointimeNotBetween(Date value1, Date value2) {
            addCriterion("JoinTime not between", value1, value2, "jointime");
            return (Criteria) this;
        }

        public Criteria andIdcardnoIsNull() {
            addCriterion("IDCardNo is null");
            return (Criteria) this;
        }

        public Criteria andIdcardnoIsNotNull() {
            addCriterion("IDCardNo is not null");
            return (Criteria) this;
        }

        public Criteria andIdcardnoEqualTo(String value) {
            addCriterion("IDCardNo =", value, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoNotEqualTo(String value) {
            addCriterion("IDCardNo <>", value, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoGreaterThan(String value) {
            addCriterion("IDCardNo >", value, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoGreaterThanOrEqualTo(String value) {
            addCriterion("IDCardNo >=", value, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoLessThan(String value) {
            addCriterion("IDCardNo <", value, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoLessThanOrEqualTo(String value) {
            addCriterion("IDCardNo <=", value, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoLike(String value) {
            addCriterion("IDCardNo like", value, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoNotLike(String value) {
            addCriterion("IDCardNo not like", value, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoIn(List<String> values) {
            addCriterion("IDCardNo in", values, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoNotIn(List<String> values) {
            addCriterion("IDCardNo not in", values, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoBetween(String value1, String value2) {
            addCriterion("IDCardNo between", value1, value2, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoNotBetween(String value1, String value2) {
            addCriterion("IDCardNo not between", value1, value2, "idcardno");
            return (Criteria) this;
        }

        public Criteria andDutyIsNull() {
            addCriterion("Duty is null");
            return (Criteria) this;
        }

        public Criteria andDutyIsNotNull() {
            addCriterion("Duty is not null");
            return (Criteria) this;
        }

        public Criteria andDutyEqualTo(String value) {
            addCriterion("Duty =", value, "duty");
            return (Criteria) this;
        }

        public Criteria andDutyNotEqualTo(String value) {
            addCriterion("Duty <>", value, "duty");
            return (Criteria) this;
        }

        public Criteria andDutyGreaterThan(String value) {
            addCriterion("Duty >", value, "duty");
            return (Criteria) this;
        }

        public Criteria andDutyGreaterThanOrEqualTo(String value) {
            addCriterion("Duty >=", value, "duty");
            return (Criteria) this;
        }

        public Criteria andDutyLessThan(String value) {
            addCriterion("Duty <", value, "duty");
            return (Criteria) this;
        }

        public Criteria andDutyLessThanOrEqualTo(String value) {
            addCriterion("Duty <=", value, "duty");
            return (Criteria) this;
        }

        public Criteria andDutyLike(String value) {
            addCriterion("Duty like", value, "duty");
            return (Criteria) this;
        }

        public Criteria andDutyNotLike(String value) {
            addCriterion("Duty not like", value, "duty");
            return (Criteria) this;
        }

        public Criteria andDutyIn(List<String> values) {
            addCriterion("Duty in", values, "duty");
            return (Criteria) this;
        }

        public Criteria andDutyNotIn(List<String> values) {
            addCriterion("Duty not in", values, "duty");
            return (Criteria) this;
        }

        public Criteria andDutyBetween(String value1, String value2) {
            addCriterion("Duty between", value1, value2, "duty");
            return (Criteria) this;
        }

        public Criteria andDutyNotBetween(String value1, String value2) {
            addCriterion("Duty not between", value1, value2, "duty");
            return (Criteria) this;
        }

        public Criteria andStarttimeIsNull() {
            addCriterion("StartTime is null");
            return (Criteria) this;
        }

        public Criteria andStarttimeIsNotNull() {
            addCriterion("StartTime is not null");
            return (Criteria) this;
        }

        public Criteria andStarttimeEqualTo(Date value) {
            addCriterion("StartTime =", value, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeNotEqualTo(Date value) {
            addCriterion("StartTime <>", value, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeGreaterThan(Date value) {
            addCriterion("StartTime >", value, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeGreaterThanOrEqualTo(Date value) {
            addCriterion("StartTime >=", value, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeLessThan(Date value) {
            addCriterion("StartTime <", value, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeLessThanOrEqualTo(Date value) {
            addCriterion("StartTime <=", value, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeIn(List<Date> values) {
            addCriterion("StartTime in", values, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeNotIn(List<Date> values) {
            addCriterion("StartTime not in", values, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeBetween(Date value1, Date value2) {
            addCriterion("StartTime between", value1, value2, "starttime");
            return (Criteria) this;
        }

        public Criteria andStarttimeNotBetween(Date value1, Date value2) {
            addCriterion("StartTime not between", value1, value2, "starttime");
            return (Criteria) this;
        }

        public Criteria andAddtimeIsNull() {
            addCriterion("AddTime is null");
            return (Criteria) this;
        }

        public Criteria andAddtimeIsNotNull() {
            addCriterion("AddTime is not null");
            return (Criteria) this;
        }

        public Criteria andAddtimeEqualTo(Date value) {
            addCriterion("AddTime =", value, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeNotEqualTo(Date value) {
            addCriterion("AddTime <>", value, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeGreaterThan(Date value) {
            addCriterion("AddTime >", value, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("AddTime >=", value, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeLessThan(Date value) {
            addCriterion("AddTime <", value, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeLessThanOrEqualTo(Date value) {
            addCriterion("AddTime <=", value, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeIn(List<Date> values) {
            addCriterion("AddTime in", values, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeNotIn(List<Date> values) {
            addCriterion("AddTime not in", values, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeBetween(Date value1, Date value2) {
            addCriterion("AddTime between", value1, value2, "addtime");
            return (Criteria) this;
        }

        public Criteria andAddtimeNotBetween(Date value1, Date value2) {
            addCriterion("AddTime not between", value1, value2, "addtime");
            return (Criteria) this;
        }

        public Criteria andTechnicalIsNull() {
            addCriterion("Technical is null");
            return (Criteria) this;
        }

        public Criteria andTechnicalIsNotNull() {
            addCriterion("Technical is not null");
            return (Criteria) this;
        }

        public Criteria andTechnicalEqualTo(String value) {
            addCriterion("Technical =", value, "technical");
            return (Criteria) this;
        }

        public Criteria andTechnicalNotEqualTo(String value) {
            addCriterion("Technical <>", value, "technical");
            return (Criteria) this;
        }

        public Criteria andTechnicalGreaterThan(String value) {
            addCriterion("Technical >", value, "technical");
            return (Criteria) this;
        }

        public Criteria andTechnicalGreaterThanOrEqualTo(String value) {
            addCriterion("Technical >=", value, "technical");
            return (Criteria) this;
        }

        public Criteria andTechnicalLessThan(String value) {
            addCriterion("Technical <", value, "technical");
            return (Criteria) this;
        }

        public Criteria andTechnicalLessThanOrEqualTo(String value) {
            addCriterion("Technical <=", value, "technical");
            return (Criteria) this;
        }

        public Criteria andTechnicalLike(String value) {
            addCriterion("Technical like", value, "technical");
            return (Criteria) this;
        }

        public Criteria andTechnicalNotLike(String value) {
            addCriterion("Technical not like", value, "technical");
            return (Criteria) this;
        }

        public Criteria andTechnicalIn(List<String> values) {
            addCriterion("Technical in", values, "technical");
            return (Criteria) this;
        }

        public Criteria andTechnicalNotIn(List<String> values) {
            addCriterion("Technical not in", values, "technical");
            return (Criteria) this;
        }

        public Criteria andTechnicalBetween(String value1, String value2) {
            addCriterion("Technical between", value1, value2, "technical");
            return (Criteria) this;
        }

        public Criteria andTechnicalNotBetween(String value1, String value2) {
            addCriterion("Technical not between", value1, value2, "technical");
            return (Criteria) this;
        }

        public Criteria andDepartIsNull() {
            addCriterion("Depart is null");
            return (Criteria) this;
        }

        public Criteria andDepartIsNotNull() {
            addCriterion("Depart is not null");
            return (Criteria) this;
        }

        public Criteria andDepartEqualTo(String value) {
            addCriterion("Depart =", value, "depart");
            return (Criteria) this;
        }

        public Criteria andDepartNotEqualTo(String value) {
            addCriterion("Depart <>", value, "depart");
            return (Criteria) this;
        }

        public Criteria andDepartGreaterThan(String value) {
            addCriterion("Depart >", value, "depart");
            return (Criteria) this;
        }

        public Criteria andDepartGreaterThanOrEqualTo(String value) {
            addCriterion("Depart >=", value, "depart");
            return (Criteria) this;
        }

        public Criteria andDepartLessThan(String value) {
            addCriterion("Depart <", value, "depart");
            return (Criteria) this;
        }

        public Criteria andDepartLessThanOrEqualTo(String value) {
            addCriterion("Depart <=", value, "depart");
            return (Criteria) this;
        }

        public Criteria andDepartLike(String value) {
            addCriterion("Depart like", value, "depart");
            return (Criteria) this;
        }

        public Criteria andDepartNotLike(String value) {
            addCriterion("Depart not like", value, "depart");
            return (Criteria) this;
        }

        public Criteria andDepartIn(List<String> values) {
            addCriterion("Depart in", values, "depart");
            return (Criteria) this;
        }

        public Criteria andDepartNotIn(List<String> values) {
            addCriterion("Depart not in", values, "depart");
            return (Criteria) this;
        }

        public Criteria andDepartBetween(String value1, String value2) {
            addCriterion("Depart between", value1, value2, "depart");
            return (Criteria) this;
        }

        public Criteria andDepartNotBetween(String value1, String value2) {
            addCriterion("Depart not between", value1, value2, "depart");
            return (Criteria) this;
        }

        public Criteria andMarriageIsNull() {
            addCriterion("Marriage is null");
            return (Criteria) this;
        }

        public Criteria andMarriageIsNotNull() {
            addCriterion("Marriage is not null");
            return (Criteria) this;
        }

        public Criteria andMarriageEqualTo(String value) {
            addCriterion("Marriage =", value, "marriage");
            return (Criteria) this;
        }

        public Criteria andMarriageNotEqualTo(String value) {
            addCriterion("Marriage <>", value, "marriage");
            return (Criteria) this;
        }

        public Criteria andMarriageGreaterThan(String value) {
            addCriterion("Marriage >", value, "marriage");
            return (Criteria) this;
        }

        public Criteria andMarriageGreaterThanOrEqualTo(String value) {
            addCriterion("Marriage >=", value, "marriage");
            return (Criteria) this;
        }

        public Criteria andMarriageLessThan(String value) {
            addCriterion("Marriage <", value, "marriage");
            return (Criteria) this;
        }

        public Criteria andMarriageLessThanOrEqualTo(String value) {
            addCriterion("Marriage <=", value, "marriage");
            return (Criteria) this;
        }

        public Criteria andMarriageLike(String value) {
            addCriterion("Marriage like", value, "marriage");
            return (Criteria) this;
        }

        public Criteria andMarriageNotLike(String value) {
            addCriterion("Marriage not like", value, "marriage");
            return (Criteria) this;
        }

        public Criteria andMarriageIn(List<String> values) {
            addCriterion("Marriage in", values, "marriage");
            return (Criteria) this;
        }

        public Criteria andMarriageNotIn(List<String> values) {
            addCriterion("Marriage not in", values, "marriage");
            return (Criteria) this;
        }

        public Criteria andMarriageBetween(String value1, String value2) {
            addCriterion("Marriage between", value1, value2, "marriage");
            return (Criteria) this;
        }

        public Criteria andMarriageNotBetween(String value1, String value2) {
            addCriterion("Marriage not between", value1, value2, "marriage");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("Address is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("Address is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("Address =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("Address <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("Address >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("Address >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("Address <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("Address <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("Address like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("Address not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("Address in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("Address not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("Address between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("Address not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andHometelIsNull() {
            addCriterion("HomeTel is null");
            return (Criteria) this;
        }

        public Criteria andHometelIsNotNull() {
            addCriterion("HomeTel is not null");
            return (Criteria) this;
        }

        public Criteria andHometelEqualTo(String value) {
            addCriterion("HomeTel =", value, "hometel");
            return (Criteria) this;
        }

        public Criteria andHometelNotEqualTo(String value) {
            addCriterion("HomeTel <>", value, "hometel");
            return (Criteria) this;
        }

        public Criteria andHometelGreaterThan(String value) {
            addCriterion("HomeTel >", value, "hometel");
            return (Criteria) this;
        }

        public Criteria andHometelGreaterThanOrEqualTo(String value) {
            addCriterion("HomeTel >=", value, "hometel");
            return (Criteria) this;
        }

        public Criteria andHometelLessThan(String value) {
            addCriterion("HomeTel <", value, "hometel");
            return (Criteria) this;
        }

        public Criteria andHometelLessThanOrEqualTo(String value) {
            addCriterion("HomeTel <=", value, "hometel");
            return (Criteria) this;
        }

        public Criteria andHometelLike(String value) {
            addCriterion("HomeTel like", value, "hometel");
            return (Criteria) this;
        }

        public Criteria andHometelNotLike(String value) {
            addCriterion("HomeTel not like", value, "hometel");
            return (Criteria) this;
        }

        public Criteria andHometelIn(List<String> values) {
            addCriterion("HomeTel in", values, "hometel");
            return (Criteria) this;
        }

        public Criteria andHometelNotIn(List<String> values) {
            addCriterion("HomeTel not in", values, "hometel");
            return (Criteria) this;
        }

        public Criteria andHometelBetween(String value1, String value2) {
            addCriterion("HomeTel between", value1, value2, "hometel");
            return (Criteria) this;
        }

        public Criteria andHometelNotBetween(String value1, String value2) {
            addCriterion("HomeTel not between", value1, value2, "hometel");
            return (Criteria) this;
        }

        public Criteria andBpIsNull() {
            addCriterion("BP is null");
            return (Criteria) this;
        }

        public Criteria andBpIsNotNull() {
            addCriterion("BP is not null");
            return (Criteria) this;
        }

        public Criteria andBpEqualTo(String value) {
            addCriterion("BP =", value, "bp");
            return (Criteria) this;
        }

        public Criteria andBpNotEqualTo(String value) {
            addCriterion("BP <>", value, "bp");
            return (Criteria) this;
        }

        public Criteria andBpGreaterThan(String value) {
            addCriterion("BP >", value, "bp");
            return (Criteria) this;
        }

        public Criteria andBpGreaterThanOrEqualTo(String value) {
            addCriterion("BP >=", value, "bp");
            return (Criteria) this;
        }

        public Criteria andBpLessThan(String value) {
            addCriterion("BP <", value, "bp");
            return (Criteria) this;
        }

        public Criteria andBpLessThanOrEqualTo(String value) {
            addCriterion("BP <=", value, "bp");
            return (Criteria) this;
        }

        public Criteria andBpLike(String value) {
            addCriterion("BP like", value, "bp");
            return (Criteria) this;
        }

        public Criteria andBpNotLike(String value) {
            addCriterion("BP not like", value, "bp");
            return (Criteria) this;
        }

        public Criteria andBpIn(List<String> values) {
            addCriterion("BP in", values, "bp");
            return (Criteria) this;
        }

        public Criteria andBpNotIn(List<String> values) {
            addCriterion("BP not in", values, "bp");
            return (Criteria) this;
        }

        public Criteria andBpBetween(String value1, String value2) {
            addCriterion("BP between", value1, value2, "bp");
            return (Criteria) this;
        }

        public Criteria andBpNotBetween(String value1, String value2) {
            addCriterion("BP not between", value1, value2, "bp");
            return (Criteria) this;
        }

        public Criteria andMobtelIsNull() {
            addCriterion("MobTel is null");
            return (Criteria) this;
        }

        public Criteria andMobtelIsNotNull() {
            addCriterion("MobTel is not null");
            return (Criteria) this;
        }

        public Criteria andMobtelEqualTo(String value) {
            addCriterion("MobTel =", value, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelNotEqualTo(String value) {
            addCriterion("MobTel <>", value, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelGreaterThan(String value) {
            addCriterion("MobTel >", value, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelGreaterThanOrEqualTo(String value) {
            addCriterion("MobTel >=", value, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelLessThan(String value) {
            addCriterion("MobTel <", value, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelLessThanOrEqualTo(String value) {
            addCriterion("MobTel <=", value, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelLike(String value) {
            addCriterion("MobTel like", value, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelNotLike(String value) {
            addCriterion("MobTel not like", value, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelIn(List<String> values) {
            addCriterion("MobTel in", values, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelNotIn(List<String> values) {
            addCriterion("MobTel not in", values, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelBetween(String value1, String value2) {
            addCriterion("MobTel between", value1, value2, "mobtel");
            return (Criteria) this;
        }

        public Criteria andMobtelNotBetween(String value1, String value2) {
            addCriterion("MobTel not between", value1, value2, "mobtel");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("Email is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("Email is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("Email =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("Email <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("Email >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("Email >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("Email <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("Email <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("Email like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("Email not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("Email in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("Email not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("Email between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("Email not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andTelphoneIsNull() {
            addCriterion("TelPhone is null");
            return (Criteria) this;
        }

        public Criteria andTelphoneIsNotNull() {
            addCriterion("TelPhone is not null");
            return (Criteria) this;
        }

        public Criteria andTelphoneEqualTo(String value) {
            addCriterion("TelPhone =", value, "telphone");
            return (Criteria) this;
        }

        public Criteria andTelphoneNotEqualTo(String value) {
            addCriterion("TelPhone <>", value, "telphone");
            return (Criteria) this;
        }

        public Criteria andTelphoneGreaterThan(String value) {
            addCriterion("TelPhone >", value, "telphone");
            return (Criteria) this;
        }

        public Criteria andTelphoneGreaterThanOrEqualTo(String value) {
            addCriterion("TelPhone >=", value, "telphone");
            return (Criteria) this;
        }

        public Criteria andTelphoneLessThan(String value) {
            addCriterion("TelPhone <", value, "telphone");
            return (Criteria) this;
        }

        public Criteria andTelphoneLessThanOrEqualTo(String value) {
            addCriterion("TelPhone <=", value, "telphone");
            return (Criteria) this;
        }

        public Criteria andTelphoneLike(String value) {
            addCriterion("TelPhone like", value, "telphone");
            return (Criteria) this;
        }

        public Criteria andTelphoneNotLike(String value) {
            addCriterion("TelPhone not like", value, "telphone");
            return (Criteria) this;
        }

        public Criteria andTelphoneIn(List<String> values) {
            addCriterion("TelPhone in", values, "telphone");
            return (Criteria) this;
        }

        public Criteria andTelphoneNotIn(List<String> values) {
            addCriterion("TelPhone not in", values, "telphone");
            return (Criteria) this;
        }

        public Criteria andTelphoneBetween(String value1, String value2) {
            addCriterion("TelPhone between", value1, value2, "telphone");
            return (Criteria) this;
        }

        public Criteria andTelphoneNotBetween(String value1, String value2) {
            addCriterion("TelPhone not between", value1, value2, "telphone");
            return (Criteria) this;
        }

        public Criteria andExtensionIsNull() {
            addCriterion("Extension is null");
            return (Criteria) this;
        }

        public Criteria andExtensionIsNotNull() {
            addCriterion("Extension is not null");
            return (Criteria) this;
        }

        public Criteria andExtensionEqualTo(String value) {
            addCriterion("Extension =", value, "extension");
            return (Criteria) this;
        }

        public Criteria andExtensionNotEqualTo(String value) {
            addCriterion("Extension <>", value, "extension");
            return (Criteria) this;
        }

        public Criteria andExtensionGreaterThan(String value) {
            addCriterion("Extension >", value, "extension");
            return (Criteria) this;
        }

        public Criteria andExtensionGreaterThanOrEqualTo(String value) {
            addCriterion("Extension >=", value, "extension");
            return (Criteria) this;
        }

        public Criteria andExtensionLessThan(String value) {
            addCriterion("Extension <", value, "extension");
            return (Criteria) this;
        }

        public Criteria andExtensionLessThanOrEqualTo(String value) {
            addCriterion("Extension <=", value, "extension");
            return (Criteria) this;
        }

        public Criteria andExtensionLike(String value) {
            addCriterion("Extension like", value, "extension");
            return (Criteria) this;
        }

        public Criteria andExtensionNotLike(String value) {
            addCriterion("Extension not like", value, "extension");
            return (Criteria) this;
        }

        public Criteria andExtensionIn(List<String> values) {
            addCriterion("Extension in", values, "extension");
            return (Criteria) this;
        }

        public Criteria andExtensionNotIn(List<String> values) {
            addCriterion("Extension not in", values, "extension");
            return (Criteria) this;
        }

        public Criteria andExtensionBetween(String value1, String value2) {
            addCriterion("Extension between", value1, value2, "extension");
            return (Criteria) this;
        }

        public Criteria andExtensionNotBetween(String value1, String value2) {
            addCriterion("Extension not between", value1, value2, "extension");
            return (Criteria) this;
        }

        public Criteria andPostnoIsNull() {
            addCriterion("PostNo is null");
            return (Criteria) this;
        }

        public Criteria andPostnoIsNotNull() {
            addCriterion("PostNo is not null");
            return (Criteria) this;
        }

        public Criteria andPostnoEqualTo(String value) {
            addCriterion("PostNo =", value, "postno");
            return (Criteria) this;
        }

        public Criteria andPostnoNotEqualTo(String value) {
            addCriterion("PostNo <>", value, "postno");
            return (Criteria) this;
        }

        public Criteria andPostnoGreaterThan(String value) {
            addCriterion("PostNo >", value, "postno");
            return (Criteria) this;
        }

        public Criteria andPostnoGreaterThanOrEqualTo(String value) {
            addCriterion("PostNo >=", value, "postno");
            return (Criteria) this;
        }

        public Criteria andPostnoLessThan(String value) {
            addCriterion("PostNo <", value, "postno");
            return (Criteria) this;
        }

        public Criteria andPostnoLessThanOrEqualTo(String value) {
            addCriterion("PostNo <=", value, "postno");
            return (Criteria) this;
        }

        public Criteria andPostnoLike(String value) {
            addCriterion("PostNo like", value, "postno");
            return (Criteria) this;
        }

        public Criteria andPostnoNotLike(String value) {
            addCriterion("PostNo not like", value, "postno");
            return (Criteria) this;
        }

        public Criteria andPostnoIn(List<String> values) {
            addCriterion("PostNo in", values, "postno");
            return (Criteria) this;
        }

        public Criteria andPostnoNotIn(List<String> values) {
            addCriterion("PostNo not in", values, "postno");
            return (Criteria) this;
        }

        public Criteria andPostnoBetween(String value1, String value2) {
            addCriterion("PostNo between", value1, value2, "postno");
            return (Criteria) this;
        }

        public Criteria andPostnoNotBetween(String value1, String value2) {
            addCriterion("PostNo not between", value1, value2, "postno");
            return (Criteria) this;
        }

        public Criteria andStorecodeIsNull() {
            addCriterion("StoreCode is null");
            return (Criteria) this;
        }

        public Criteria andStorecodeIsNotNull() {
            addCriterion("StoreCode is not null");
            return (Criteria) this;
        }

        public Criteria andStorecodeEqualTo(String value) {
            addCriterion("StoreCode =", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotEqualTo(String value) {
            addCriterion("StoreCode <>", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeGreaterThan(String value) {
            addCriterion("StoreCode >", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeGreaterThanOrEqualTo(String value) {
            addCriterion("StoreCode >=", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLessThan(String value) {
            addCriterion("StoreCode <", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLessThanOrEqualTo(String value) {
            addCriterion("StoreCode <=", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeLike(String value) {
            addCriterion("StoreCode like", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotLike(String value) {
            addCriterion("StoreCode not like", value, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeIn(List<String> values) {
            addCriterion("StoreCode in", values, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotIn(List<String> values) {
            addCriterion("StoreCode not in", values, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeBetween(String value1, String value2) {
            addCriterion("StoreCode between", value1, value2, "storecode");
            return (Criteria) this;
        }

        public Criteria andStorecodeNotBetween(String value1, String value2) {
            addCriterion("StoreCode not between", value1, value2, "storecode");
            return (Criteria) this;
        }

        public Criteria andNewupdateIsNull() {
            addCriterion("NewUpdate is null");
            return (Criteria) this;
        }

        public Criteria andNewupdateIsNotNull() {
            addCriterion("NewUpdate is not null");
            return (Criteria) this;
        }

        public Criteria andNewupdateEqualTo(Date value) {
            addCriterion("NewUpdate =", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateNotEqualTo(Date value) {
            addCriterion("NewUpdate <>", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateGreaterThan(Date value) {
            addCriterion("NewUpdate >", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateGreaterThanOrEqualTo(Date value) {
            addCriterion("NewUpdate >=", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateLessThan(Date value) {
            addCriterion("NewUpdate <", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateLessThanOrEqualTo(Date value) {
            addCriterion("NewUpdate <=", value, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateIn(List<Date> values) {
            addCriterion("NewUpdate in", values, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateNotIn(List<Date> values) {
            addCriterion("NewUpdate not in", values, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateBetween(Date value1, Date value2) {
            addCriterion("NewUpdate between", value1, value2, "newupdate");
            return (Criteria) this;
        }

        public Criteria andNewupdateNotBetween(Date value1, Date value2) {
            addCriterion("NewUpdate not between", value1, value2, "newupdate");
            return (Criteria) this;
        }

        public Criteria andFriendtelIsNull() {
            addCriterion("FriendTel is null");
            return (Criteria) this;
        }

        public Criteria andFriendtelIsNotNull() {
            addCriterion("FriendTel is not null");
            return (Criteria) this;
        }

        public Criteria andFriendtelEqualTo(String value) {
            addCriterion("FriendTel =", value, "friendtel");
            return (Criteria) this;
        }

        public Criteria andFriendtelNotEqualTo(String value) {
            addCriterion("FriendTel <>", value, "friendtel");
            return (Criteria) this;
        }

        public Criteria andFriendtelGreaterThan(String value) {
            addCriterion("FriendTel >", value, "friendtel");
            return (Criteria) this;
        }

        public Criteria andFriendtelGreaterThanOrEqualTo(String value) {
            addCriterion("FriendTel >=", value, "friendtel");
            return (Criteria) this;
        }

        public Criteria andFriendtelLessThan(String value) {
            addCriterion("FriendTel <", value, "friendtel");
            return (Criteria) this;
        }

        public Criteria andFriendtelLessThanOrEqualTo(String value) {
            addCriterion("FriendTel <=", value, "friendtel");
            return (Criteria) this;
        }

        public Criteria andFriendtelLike(String value) {
            addCriterion("FriendTel like", value, "friendtel");
            return (Criteria) this;
        }

        public Criteria andFriendtelNotLike(String value) {
            addCriterion("FriendTel not like", value, "friendtel");
            return (Criteria) this;
        }

        public Criteria andFriendtelIn(List<String> values) {
            addCriterion("FriendTel in", values, "friendtel");
            return (Criteria) this;
        }

        public Criteria andFriendtelNotIn(List<String> values) {
            addCriterion("FriendTel not in", values, "friendtel");
            return (Criteria) this;
        }

        public Criteria andFriendtelBetween(String value1, String value2) {
            addCriterion("FriendTel between", value1, value2, "friendtel");
            return (Criteria) this;
        }

        public Criteria andFriendtelNotBetween(String value1, String value2) {
            addCriterion("FriendTel not between", value1, value2, "friendtel");
            return (Criteria) this;
        }

        public Criteria andFriendIsNull() {
            addCriterion("Friend is null");
            return (Criteria) this;
        }

        public Criteria andFriendIsNotNull() {
            addCriterion("Friend is not null");
            return (Criteria) this;
        }

        public Criteria andFriendEqualTo(String value) {
            addCriterion("Friend =", value, "friend");
            return (Criteria) this;
        }

        public Criteria andFriendNotEqualTo(String value) {
            addCriterion("Friend <>", value, "friend");
            return (Criteria) this;
        }

        public Criteria andFriendGreaterThan(String value) {
            addCriterion("Friend >", value, "friend");
            return (Criteria) this;
        }

        public Criteria andFriendGreaterThanOrEqualTo(String value) {
            addCriterion("Friend >=", value, "friend");
            return (Criteria) this;
        }

        public Criteria andFriendLessThan(String value) {
            addCriterion("Friend <", value, "friend");
            return (Criteria) this;
        }

        public Criteria andFriendLessThanOrEqualTo(String value) {
            addCriterion("Friend <=", value, "friend");
            return (Criteria) this;
        }

        public Criteria andFriendLike(String value) {
            addCriterion("Friend like", value, "friend");
            return (Criteria) this;
        }

        public Criteria andFriendNotLike(String value) {
            addCriterion("Friend not like", value, "friend");
            return (Criteria) this;
        }

        public Criteria andFriendIn(List<String> values) {
            addCriterion("Friend in", values, "friend");
            return (Criteria) this;
        }

        public Criteria andFriendNotIn(List<String> values) {
            addCriterion("Friend not in", values, "friend");
            return (Criteria) this;
        }

        public Criteria andFriendBetween(String value1, String value2) {
            addCriterion("Friend between", value1, value2, "friend");
            return (Criteria) this;
        }

        public Criteria andFriendNotBetween(String value1, String value2) {
            addCriterion("Friend not between", value1, value2, "friend");
            return (Criteria) this;
        }

        public Criteria andHometelmanIsNull() {
            addCriterion("HomeTelMan is null");
            return (Criteria) this;
        }

        public Criteria andHometelmanIsNotNull() {
            addCriterion("HomeTelMan is not null");
            return (Criteria) this;
        }

        public Criteria andHometelmanEqualTo(String value) {
            addCriterion("HomeTelMan =", value, "hometelman");
            return (Criteria) this;
        }

        public Criteria andHometelmanNotEqualTo(String value) {
            addCriterion("HomeTelMan <>", value, "hometelman");
            return (Criteria) this;
        }

        public Criteria andHometelmanGreaterThan(String value) {
            addCriterion("HomeTelMan >", value, "hometelman");
            return (Criteria) this;
        }

        public Criteria andHometelmanGreaterThanOrEqualTo(String value) {
            addCriterion("HomeTelMan >=", value, "hometelman");
            return (Criteria) this;
        }

        public Criteria andHometelmanLessThan(String value) {
            addCriterion("HomeTelMan <", value, "hometelman");
            return (Criteria) this;
        }

        public Criteria andHometelmanLessThanOrEqualTo(String value) {
            addCriterion("HomeTelMan <=", value, "hometelman");
            return (Criteria) this;
        }

        public Criteria andHometelmanLike(String value) {
            addCriterion("HomeTelMan like", value, "hometelman");
            return (Criteria) this;
        }

        public Criteria andHometelmanNotLike(String value) {
            addCriterion("HomeTelMan not like", value, "hometelman");
            return (Criteria) this;
        }

        public Criteria andHometelmanIn(List<String> values) {
            addCriterion("HomeTelMan in", values, "hometelman");
            return (Criteria) this;
        }

        public Criteria andHometelmanNotIn(List<String> values) {
            addCriterion("HomeTelMan not in", values, "hometelman");
            return (Criteria) this;
        }

        public Criteria andHometelmanBetween(String value1, String value2) {
            addCriterion("HomeTelMan between", value1, value2, "hometelman");
            return (Criteria) this;
        }

        public Criteria andHometelmanNotBetween(String value1, String value2) {
            addCriterion("HomeTelMan not between", value1, value2, "hometelman");
            return (Criteria) this;
        }

        public Criteria andAreanoIsNull() {
            addCriterion("AreaNo is null");
            return (Criteria) this;
        }

        public Criteria andAreanoIsNotNull() {
            addCriterion("AreaNo is not null");
            return (Criteria) this;
        }

        public Criteria andAreanoEqualTo(String value) {
            addCriterion("AreaNo =", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoNotEqualTo(String value) {
            addCriterion("AreaNo <>", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoGreaterThan(String value) {
            addCriterion("AreaNo >", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoGreaterThanOrEqualTo(String value) {
            addCriterion("AreaNo >=", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoLessThan(String value) {
            addCriterion("AreaNo <", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoLessThanOrEqualTo(String value) {
            addCriterion("AreaNo <=", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoLike(String value) {
            addCriterion("AreaNo like", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoNotLike(String value) {
            addCriterion("AreaNo not like", value, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoIn(List<String> values) {
            addCriterion("AreaNo in", values, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoNotIn(List<String> values) {
            addCriterion("AreaNo not in", values, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoBetween(String value1, String value2) {
            addCriterion("AreaNo between", value1, value2, "areano");
            return (Criteria) this;
        }

        public Criteria andAreanoNotBetween(String value1, String value2) {
            addCriterion("AreaNo not between", value1, value2, "areano");
            return (Criteria) this;
        }

        public Criteria andDriveridIsNull() {
            addCriterion("DriverID is null");
            return (Criteria) this;
        }

        public Criteria andDriveridIsNotNull() {
            addCriterion("DriverID is not null");
            return (Criteria) this;
        }

        public Criteria andDriveridEqualTo(String value) {
            addCriterion("DriverID =", value, "driverid");
            return (Criteria) this;
        }

        public Criteria andDriveridNotEqualTo(String value) {
            addCriterion("DriverID <>", value, "driverid");
            return (Criteria) this;
        }

        public Criteria andDriveridGreaterThan(String value) {
            addCriterion("DriverID >", value, "driverid");
            return (Criteria) this;
        }

        public Criteria andDriveridGreaterThanOrEqualTo(String value) {
            addCriterion("DriverID >=", value, "driverid");
            return (Criteria) this;
        }

        public Criteria andDriveridLessThan(String value) {
            addCriterion("DriverID <", value, "driverid");
            return (Criteria) this;
        }

        public Criteria andDriveridLessThanOrEqualTo(String value) {
            addCriterion("DriverID <=", value, "driverid");
            return (Criteria) this;
        }

        public Criteria andDriveridLike(String value) {
            addCriterion("DriverID like", value, "driverid");
            return (Criteria) this;
        }

        public Criteria andDriveridNotLike(String value) {
            addCriterion("DriverID not like", value, "driverid");
            return (Criteria) this;
        }

        public Criteria andDriveridIn(List<String> values) {
            addCriterion("DriverID in", values, "driverid");
            return (Criteria) this;
        }

        public Criteria andDriveridNotIn(List<String> values) {
            addCriterion("DriverID not in", values, "driverid");
            return (Criteria) this;
        }

        public Criteria andDriveridBetween(String value1, String value2) {
            addCriterion("DriverID between", value1, value2, "driverid");
            return (Criteria) this;
        }

        public Criteria andDriveridNotBetween(String value1, String value2) {
            addCriterion("DriverID not between", value1, value2, "driverid");
            return (Criteria) this;
        }

        public Criteria andCarrierIsNull() {
            addCriterion("Carrier is null");
            return (Criteria) this;
        }

        public Criteria andCarrierIsNotNull() {
            addCriterion("Carrier is not null");
            return (Criteria) this;
        }

        public Criteria andCarrierEqualTo(String value) {
            addCriterion("Carrier =", value, "carrier");
            return (Criteria) this;
        }

        public Criteria andCarrierNotEqualTo(String value) {
            addCriterion("Carrier <>", value, "carrier");
            return (Criteria) this;
        }

        public Criteria andCarrierGreaterThan(String value) {
            addCriterion("Carrier >", value, "carrier");
            return (Criteria) this;
        }

        public Criteria andCarrierGreaterThanOrEqualTo(String value) {
            addCriterion("Carrier >=", value, "carrier");
            return (Criteria) this;
        }

        public Criteria andCarrierLessThan(String value) {
            addCriterion("Carrier <", value, "carrier");
            return (Criteria) this;
        }

        public Criteria andCarrierLessThanOrEqualTo(String value) {
            addCriterion("Carrier <=", value, "carrier");
            return (Criteria) this;
        }

        public Criteria andCarrierLike(String value) {
            addCriterion("Carrier like", value, "carrier");
            return (Criteria) this;
        }

        public Criteria andCarrierNotLike(String value) {
            addCriterion("Carrier not like", value, "carrier");
            return (Criteria) this;
        }

        public Criteria andCarrierIn(List<String> values) {
            addCriterion("Carrier in", values, "carrier");
            return (Criteria) this;
        }

        public Criteria andCarrierNotIn(List<String> values) {
            addCriterion("Carrier not in", values, "carrier");
            return (Criteria) this;
        }

        public Criteria andCarrierBetween(String value1, String value2) {
            addCriterion("Carrier between", value1, value2, "carrier");
            return (Criteria) this;
        }

        public Criteria andCarrierNotBetween(String value1, String value2) {
            addCriterion("Carrier not between", value1, value2, "carrier");
            return (Criteria) this;
        }

        public Criteria andPersontypeIsNull() {
            addCriterion("PersonType is null");
            return (Criteria) this;
        }

        public Criteria andPersontypeIsNotNull() {
            addCriterion("PersonType is not null");
            return (Criteria) this;
        }

        public Criteria andPersontypeEqualTo(String value) {
            addCriterion("PersonType =", value, "persontype");
            return (Criteria) this;
        }

        public Criteria andPersontypeNotEqualTo(String value) {
            addCriterion("PersonType <>", value, "persontype");
            return (Criteria) this;
        }

        public Criteria andPersontypeGreaterThan(String value) {
            addCriterion("PersonType >", value, "persontype");
            return (Criteria) this;
        }

        public Criteria andPersontypeGreaterThanOrEqualTo(String value) {
            addCriterion("PersonType >=", value, "persontype");
            return (Criteria) this;
        }

        public Criteria andPersontypeLessThan(String value) {
            addCriterion("PersonType <", value, "persontype");
            return (Criteria) this;
        }

        public Criteria andPersontypeLessThanOrEqualTo(String value) {
            addCriterion("PersonType <=", value, "persontype");
            return (Criteria) this;
        }

        public Criteria andPersontypeLike(String value) {
            addCriterion("PersonType like", value, "persontype");
            return (Criteria) this;
        }

        public Criteria andPersontypeNotLike(String value) {
            addCriterion("PersonType not like", value, "persontype");
            return (Criteria) this;
        }

        public Criteria andPersontypeIn(List<String> values) {
            addCriterion("PersonType in", values, "persontype");
            return (Criteria) this;
        }

        public Criteria andPersontypeNotIn(List<String> values) {
            addCriterion("PersonType not in", values, "persontype");
            return (Criteria) this;
        }

        public Criteria andPersontypeBetween(String value1, String value2) {
            addCriterion("PersonType between", value1, value2, "persontype");
            return (Criteria) this;
        }

        public Criteria andPersontypeNotBetween(String value1, String value2) {
            addCriterion("PersonType not between", value1, value2, "persontype");
            return (Criteria) this;
        }

        public Criteria andConfirmdateIsNull() {
            addCriterion("ConfirmDate is null");
            return (Criteria) this;
        }

        public Criteria andConfirmdateIsNotNull() {
            addCriterion("ConfirmDate is not null");
            return (Criteria) this;
        }

        public Criteria andConfirmdateEqualTo(Date value) {
            addCriterion("ConfirmDate =", value, "confirmdate");
            return (Criteria) this;
        }

        public Criteria andConfirmdateNotEqualTo(Date value) {
            addCriterion("ConfirmDate <>", value, "confirmdate");
            return (Criteria) this;
        }

        public Criteria andConfirmdateGreaterThan(Date value) {
            addCriterion("ConfirmDate >", value, "confirmdate");
            return (Criteria) this;
        }

        public Criteria andConfirmdateGreaterThanOrEqualTo(Date value) {
            addCriterion("ConfirmDate >=", value, "confirmdate");
            return (Criteria) this;
        }

        public Criteria andConfirmdateLessThan(Date value) {
            addCriterion("ConfirmDate <", value, "confirmdate");
            return (Criteria) this;
        }

        public Criteria andConfirmdateLessThanOrEqualTo(Date value) {
            addCriterion("ConfirmDate <=", value, "confirmdate");
            return (Criteria) this;
        }

        public Criteria andConfirmdateIn(List<Date> values) {
            addCriterion("ConfirmDate in", values, "confirmdate");
            return (Criteria) this;
        }

        public Criteria andConfirmdateNotIn(List<Date> values) {
            addCriterion("ConfirmDate not in", values, "confirmdate");
            return (Criteria) this;
        }

        public Criteria andConfirmdateBetween(Date value1, Date value2) {
            addCriterion("ConfirmDate between", value1, value2, "confirmdate");
            return (Criteria) this;
        }

        public Criteria andConfirmdateNotBetween(Date value1, Date value2) {
            addCriterion("ConfirmDate not between", value1, value2, "confirmdate");
            return (Criteria) this;
        }

        public Criteria andConfirmtagIsNull() {
            addCriterion("ConfirmTag is null");
            return (Criteria) this;
        }

        public Criteria andConfirmtagIsNotNull() {
            addCriterion("ConfirmTag is not null");
            return (Criteria) this;
        }

        public Criteria andConfirmtagEqualTo(String value) {
            addCriterion("ConfirmTag =", value, "confirmtag");
            return (Criteria) this;
        }

        public Criteria andConfirmtagNotEqualTo(String value) {
            addCriterion("ConfirmTag <>", value, "confirmtag");
            return (Criteria) this;
        }

        public Criteria andConfirmtagGreaterThan(String value) {
            addCriterion("ConfirmTag >", value, "confirmtag");
            return (Criteria) this;
        }

        public Criteria andConfirmtagGreaterThanOrEqualTo(String value) {
            addCriterion("ConfirmTag >=", value, "confirmtag");
            return (Criteria) this;
        }

        public Criteria andConfirmtagLessThan(String value) {
            addCriterion("ConfirmTag <", value, "confirmtag");
            return (Criteria) this;
        }

        public Criteria andConfirmtagLessThanOrEqualTo(String value) {
            addCriterion("ConfirmTag <=", value, "confirmtag");
            return (Criteria) this;
        }

        public Criteria andConfirmtagLike(String value) {
            addCriterion("ConfirmTag like", value, "confirmtag");
            return (Criteria) this;
        }

        public Criteria andConfirmtagNotLike(String value) {
            addCriterion("ConfirmTag not like", value, "confirmtag");
            return (Criteria) this;
        }

        public Criteria andConfirmtagIn(List<String> values) {
            addCriterion("ConfirmTag in", values, "confirmtag");
            return (Criteria) this;
        }

        public Criteria andConfirmtagNotIn(List<String> values) {
            addCriterion("ConfirmTag not in", values, "confirmtag");
            return (Criteria) this;
        }

        public Criteria andConfirmtagBetween(String value1, String value2) {
            addCriterion("ConfirmTag between", value1, value2, "confirmtag");
            return (Criteria) this;
        }

        public Criteria andConfirmtagNotBetween(String value1, String value2) {
            addCriterion("ConfirmTag not between", value1, value2, "confirmtag");
            return (Criteria) this;
        }

        public Criteria andCarnoIsNull() {
            addCriterion("CarNo is null");
            return (Criteria) this;
        }

        public Criteria andCarnoIsNotNull() {
            addCriterion("CarNo is not null");
            return (Criteria) this;
        }

        public Criteria andCarnoEqualTo(String value) {
            addCriterion("CarNo =", value, "carno");
            return (Criteria) this;
        }

        public Criteria andCarnoNotEqualTo(String value) {
            addCriterion("CarNo <>", value, "carno");
            return (Criteria) this;
        }

        public Criteria andCarnoGreaterThan(String value) {
            addCriterion("CarNo >", value, "carno");
            return (Criteria) this;
        }

        public Criteria andCarnoGreaterThanOrEqualTo(String value) {
            addCriterion("CarNo >=", value, "carno");
            return (Criteria) this;
        }

        public Criteria andCarnoLessThan(String value) {
            addCriterion("CarNo <", value, "carno");
            return (Criteria) this;
        }

        public Criteria andCarnoLessThanOrEqualTo(String value) {
            addCriterion("CarNo <=", value, "carno");
            return (Criteria) this;
        }

        public Criteria andCarnoLike(String value) {
            addCriterion("CarNo like", value, "carno");
            return (Criteria) this;
        }

        public Criteria andCarnoNotLike(String value) {
            addCriterion("CarNo not like", value, "carno");
            return (Criteria) this;
        }

        public Criteria andCarnoIn(List<String> values) {
            addCriterion("CarNo in", values, "carno");
            return (Criteria) this;
        }

        public Criteria andCarnoNotIn(List<String> values) {
            addCriterion("CarNo not in", values, "carno");
            return (Criteria) this;
        }

        public Criteria andCarnoBetween(String value1, String value2) {
            addCriterion("CarNo between", value1, value2, "carno");
            return (Criteria) this;
        }

        public Criteria andCarnoNotBetween(String value1, String value2) {
            addCriterion("CarNo not between", value1, value2, "carno");
            return (Criteria) this;
        }

        public Criteria andPycodeIsNull() {
            addCriterion("PYCode is null");
            return (Criteria) this;
        }

        public Criteria andPycodeIsNotNull() {
            addCriterion("PYCode is not null");
            return (Criteria) this;
        }

        public Criteria andPycodeEqualTo(String value) {
            addCriterion("PYCode =", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeNotEqualTo(String value) {
            addCriterion("PYCode <>", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeGreaterThan(String value) {
            addCriterion("PYCode >", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeGreaterThanOrEqualTo(String value) {
            addCriterion("PYCode >=", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeLessThan(String value) {
            addCriterion("PYCode <", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeLessThanOrEqualTo(String value) {
            addCriterion("PYCode <=", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeLike(String value) {
            addCriterion("PYCode like", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeNotLike(String value) {
            addCriterion("PYCode not like", value, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeIn(List<String> values) {
            addCriterion("PYCode in", values, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeNotIn(List<String> values) {
            addCriterion("PYCode not in", values, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeBetween(String value1, String value2) {
            addCriterion("PYCode between", value1, value2, "pycode");
            return (Criteria) this;
        }

        public Criteria andPycodeNotBetween(String value1, String value2) {
            addCriterion("PYCode not between", value1, value2, "pycode");
            return (Criteria) this;
        }

        public Criteria andOpenflagIsNull() {
            addCriterion("OpenFlag is null");
            return (Criteria) this;
        }

        public Criteria andOpenflagIsNotNull() {
            addCriterion("OpenFlag is not null");
            return (Criteria) this;
        }

        public Criteria andOpenflagEqualTo(String value) {
            addCriterion("OpenFlag =", value, "openflag");
            return (Criteria) this;
        }

        public Criteria andOpenflagNotEqualTo(String value) {
            addCriterion("OpenFlag <>", value, "openflag");
            return (Criteria) this;
        }

        public Criteria andOpenflagGreaterThan(String value) {
            addCriterion("OpenFlag >", value, "openflag");
            return (Criteria) this;
        }

        public Criteria andOpenflagGreaterThanOrEqualTo(String value) {
            addCriterion("OpenFlag >=", value, "openflag");
            return (Criteria) this;
        }

        public Criteria andOpenflagLessThan(String value) {
            addCriterion("OpenFlag <", value, "openflag");
            return (Criteria) this;
        }

        public Criteria andOpenflagLessThanOrEqualTo(String value) {
            addCriterion("OpenFlag <=", value, "openflag");
            return (Criteria) this;
        }

        public Criteria andOpenflagLike(String value) {
            addCriterion("OpenFlag like", value, "openflag");
            return (Criteria) this;
        }

        public Criteria andOpenflagNotLike(String value) {
            addCriterion("OpenFlag not like", value, "openflag");
            return (Criteria) this;
        }

        public Criteria andOpenflagIn(List<String> values) {
            addCriterion("OpenFlag in", values, "openflag");
            return (Criteria) this;
        }

        public Criteria andOpenflagNotIn(List<String> values) {
            addCriterion("OpenFlag not in", values, "openflag");
            return (Criteria) this;
        }

        public Criteria andOpenflagBetween(String value1, String value2) {
            addCriterion("OpenFlag between", value1, value2, "openflag");
            return (Criteria) this;
        }

        public Criteria andOpenflagNotBetween(String value1, String value2) {
            addCriterion("OpenFlag not between", value1, value2, "openflag");
            return (Criteria) this;
        }

        public Criteria andLoginctiIsNull() {
            addCriterion("LoginCTI is null");
            return (Criteria) this;
        }

        public Criteria andLoginctiIsNotNull() {
            addCriterion("LoginCTI is not null");
            return (Criteria) this;
        }

        public Criteria andLoginctiEqualTo(String value) {
            addCriterion("LoginCTI =", value, "logincti");
            return (Criteria) this;
        }

        public Criteria andLoginctiNotEqualTo(String value) {
            addCriterion("LoginCTI <>", value, "logincti");
            return (Criteria) this;
        }

        public Criteria andLoginctiGreaterThan(String value) {
            addCriterion("LoginCTI >", value, "logincti");
            return (Criteria) this;
        }

        public Criteria andLoginctiGreaterThanOrEqualTo(String value) {
            addCriterion("LoginCTI >=", value, "logincti");
            return (Criteria) this;
        }

        public Criteria andLoginctiLessThan(String value) {
            addCriterion("LoginCTI <", value, "logincti");
            return (Criteria) this;
        }

        public Criteria andLoginctiLessThanOrEqualTo(String value) {
            addCriterion("LoginCTI <=", value, "logincti");
            return (Criteria) this;
        }

        public Criteria andLoginctiLike(String value) {
            addCriterion("LoginCTI like", value, "logincti");
            return (Criteria) this;
        }

        public Criteria andLoginctiNotLike(String value) {
            addCriterion("LoginCTI not like", value, "logincti");
            return (Criteria) this;
        }

        public Criteria andLoginctiIn(List<String> values) {
            addCriterion("LoginCTI in", values, "logincti");
            return (Criteria) this;
        }

        public Criteria andLoginctiNotIn(List<String> values) {
            addCriterion("LoginCTI not in", values, "logincti");
            return (Criteria) this;
        }

        public Criteria andLoginctiBetween(String value1, String value2) {
            addCriterion("LoginCTI between", value1, value2, "logincti");
            return (Criteria) this;
        }

        public Criteria andLoginctiNotBetween(String value1, String value2) {
            addCriterion("LoginCTI not between", value1, value2, "logincti");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}